...计算第三个单元格的和 用IF函数和AND集合可以吗答:=if(and(A1>0,A1<8),B1,C1)……VS……=if((A1>0)*(A1<8),B1,C1)——对比and和 =if(or(A1>0,A1<8),B1,C1)……VS……=if((A1<0)+(A1>8),B1,C1)——对比or和+ 以上两种情况是完全可以互换的(等价的)。由此,初学函数的朋友就容易产生这么一种理解:“*就是and(而且的...
excel中if/or/and函数嵌套答:=IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀",IF(OR(C14<60,D14<60,E14<60,F14<60),"差","及格"))=IF(OR(C14<60,D14<60,E14<60,F14<60),"差",IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀","及格"))=IF(COUNTIF(C14:F14,">=80")=4,"优秀",...